DECLARE @ObjectName NVARCHAR(100)
SELECT @ObjectName = CONCAT('ALTER TABLE RemoteXDAInstance DROP CONSTRAINT ', (SELECT name 
FROM sys.foreign_keys
WHERE referenced_object_id = object_id('UserAccount') AND parent_object_id = object_id('RemoteXDAInstance')
))
EXECUTE sp_executesql @ObjectName
GO
ALTER TABLE RemoteXDAInstance
DROP COLUMN UserAccountID
GO

ALTER TABLE RemoteXDAInstance ADD
RegistrationKey VARCHAR(50) NOT NULL DEFAULT(''),
APIToken VARCHAR(50) NOT NULL DEFAULT('')
GO

Insert into ValueListGroup (Name, Description) VALUES('SpareChannel', 'List of spare channel names and descriptions for filtering in new meter wizard, case insensitive.')
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Virtual Spare',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare Virtual',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Current Spare',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare Current',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Voltage Spare',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare Voltage',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare Trigger',0)
GO
Insert into ValueList (GroupID, Value, SortOrder) VALUES((SELECT ID FROM ValueListGroup WHERE name = 'SpareChannel'), 'Spare Channel',0)
GO

CREATE TABLE [OpenSEE.Setting](
    ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    Name VARCHAR(200) NOT NULL UNIQUE,
    Value VARCHAR(MAX) NULL,
    DefaultValue VARCHAR(MAX) NULL
)
GO

INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('applicationName', 'OpenSEE', 'OpenSEE')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('applicationDescription', 'Event Viewing Engine', 'Event Viewing Engine')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('applicationKeywords', 'open source, utility, browser, power quality, management', 'open source, utility, browser, power quality, management')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('bootstrapTheme', '~/Content/bootstrap-theme.css', '~/Content/bootstrap-theme.css')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('useLLVoltage', 'false', 'false')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('SlidingCacheExpiration', '2.0', '2.0')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('maxSampleRate', '-1', '-1')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('minSampleRate', '-1', '-1')
GO
INSERT INTO [OpenSEE.Setting](Name, Value, DefaultValue) VALUES('maxFFTHarmonic', '50', '50')
GO